Direct Connections Data Source Configuration

The Direct Connections Configure Data Source Wizard offers more choices than the Windows ODBC Wizard, but less information about each selection. To use it, you will need to know the format expected by the data source you are using.

See a list of the direct connection data source drivers that Workflow supports.

• Microsoft Access 2003
• Microsoft Access 2007/2010
• CSV
• CSV 2010
• Microsoft Excel 2003
• Microsoft Excel 2007/2010
• Microsoft FoxPro
• Informix
• OracleOdbc
• OracleODP
• Pervasive
• MSSQL
• MySQL

Note: Excel only accepts one connection at a time, so using Excel as your data source driver is usually not a good choice for production.

Third-Party Database Selection

Select a Data Source Type

• Choose ODBC, OLE, or Direct.

Select a Data Source Driver

• Choose a driver. The available selections will depend on the selected data source type.

Third-Party Database Information

• Specify the server, database name, and any other information for your database.
• You may need to specify the authentication information for the data source. Windows Authentication will use the login information of the Windows user the Workflow Server is running as. To use Server Authentication, enter a user name and password.
• Click Finish.